SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 56055: The getDBMirrorData.sas job fails and returns "ERROR: Some character data was lost during transcoding in the dataset WORK.EAM_ALERT_DEFINITION..."

DetailsAboutRate It

The getDBMirrorData.sas job called by the master_apm_etl.sh and master_acm_etl.sh flows fails under UNIX when the following conditions apply:

  • The SAS session executing the getDBMirrorData.sas job is using latin9 encoding.
  • The WORK.EAM_ALERT_DEFINITION table has an entry containing the following description:
    Zombies Processes are leftover bits of dead processes that haven't been cleaned up. Indication of a application problem.

In this scenario, the getDBMirrorData.sas job fails with the following error message:

ERROR: Some character data was lost during transcoding in the dataset WORK.EAM_ALERT_DEFINITION. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding.

To work around the problem, complete the following steps:

  1. Open the alerts.xml file located here: SAS-configuration-directory/Lev1/Web/SASEnvironmentManager/emi-framework/ConfigureFiles/Kits/emi-framework/sasev/alerts.xml.
  2. In this file, change haven't to have not.
  3. Reload the kit installer step by running ./bin/ev_kit_installer.sh -f -k emi-framework. This forces the installer to reload and replace the alert definitions.
  4. Rerun the step that failed and triggered the error. For example, if the step in which you enable Agent-Collected Metric (ACM) failed, then you need to rerun ./emi_init.sh --enable ACM.


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Environment Manager Enablement Kit Server64-bit Enabled AIX2.42.59.4 TS1M29.4 TS1M4
HP-UX IPF2.42.59.4 TS1M29.4 TS1M4
Linux for x642.42.59.4 TS1M29.4 TS1M4
Solaris for x642.42.59.4 TS1M29.4 TS1M4
64-bit Enabled Solaris2.42.59.4 TS1M29.4 TS1M4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.